SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023276 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023276 [ RunTime:0.001586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (863797,936201,729152,750494,355618,354567,266966,413689,1033342,404631,372153,361932,102915,744332,419846,140229,582418,625599,731013,251532,439367,656903,471578,838480,336839,152935,704377,654053,950853,407845,780930,244252,684276,707560,414957,415600,875189,190541,513540,809255,308551,251319,922600,33452,146813,1037425,907665,17611,869875,940900,306501,385190,698032,266053,121758,830080,871736,140670,792122,607122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]