SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028849 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028849 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857368,142104,490148,393942,378904,989446,205495,284853,876162,722120,809574,800153,147299,1019692,521872,961721,507970,82286,63326,698529,158697,217582,803653,243491,35005,863554,607042,802116,146886,668913,396052,803998,601200,262464,687596,1046524,788796,938705,3609,10276,79306,816394,634698,884006,105426,211523,172483,425535,233867,319787,696501,951173,567858,555965,898225,413116,891173,137992,636234,41068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028849 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028849 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003901s ]