SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644509 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644509 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546571,287263,140728,684872,223505,770082,190600,256466,795068,37793,714546,592627,743345,777128,306185,49753,99704,1035624,877860,585489,311736,957937,545644,67045,87751,550275,884738,34688,131458,409917,373115,101094,316377,309295,860779,732043,1038158,196501,607211,360515,896189,920433,370809,42838,726205,628655,806123,6080,829609,843118,809879,487568,87090,170876,594794,894899,108954,695589,47884,10175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]