SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404888 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404888 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (858119,430952,833626,670003,72073,947876,1020211,58257,582536,811050,547160,918571,1003072,453987,1023985,62804,98593,293640,458862,548014,4428,455750,528929,980268,850379,136654,351183,500701,224184,248027,691580,955921,113742,921027,936373,190865,505969,122623,369353,206000,277209,387082,418791,864422,888306,28091,51640,377418,747429,1002464,1044094,144623,71638,645597,1001394,1011550,1007631,469158,71333,600326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]