SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508440 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508440 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277794,335885,600461,92854,589579,514822,336058,813610,364840,47432,635066,754185,408222,150336,37051,302825,384512,990672,302012,596659,5162,810501,846930,718011,306678,585481,527678,907435,793757,169162,919461,394777,497989,1042319,350467,321123,53699,932137,181746,914768,693424,150526,316626,371693,19983,1010959,353472,826514,260457,733109,389905,390119,594153,915386,958104,127907,528999,683148,155691,345099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]