SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414646 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414646 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830987,416372,949745,412231,840772,153456,179783,116585,1030755,354828,741949,764203,1016460,881067,714149,865921,534568,664663,606089,4750,56753,442680,133157,447685,271160,316442,481471,633217,193946,170990,914457,548045,753270,923698,11610,361198,503013,330648,957368,83453,1031022,436131,463077,721371,370873,944808,895563,837301,689280,908014,518173,495567,838175,1016535,434211,662432,904961,1040016,388698,693192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414646 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414646 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]