SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 963310 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 963310 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280081,494280,1207,816697,909978,175232,667617,148568,843294,211834,665112,514418,373855,458870,806610,202544,694441,119580,837290,377232,435036,345574,453831,149132,323038,495776,443781,666684,465453,606699,441852,143087,733472,660673,136001,851063,482394,459126,393330,131083,886604,491355,879034,448998,474352,762526,512749,387141,532417,557310,750138,198709,1032634,1040608,95777,377689,468918,709255,67014,1038709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 963310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 963310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]