SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040610 LIMIT 1 [ RunTime:0.002516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040610 [ RunTime:0.006125s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162701,715755,752879,1038274,775229,188765,223002,951043,436254,991695,673214,28734,501728,490963,853578,208780,1024329,332489,837264,514439,424032,740047,476639,680315,713121,896768,51586,691166,397629,941284,944538,229643,671847,517347,593807,446217,306916,242696,745520,811441,590345,799123,792152,794696,66586,90870,925164,770739,520257,214847,938837,914985,827920,571411,578573,534958,89806,100626,286177,717442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004291s ]