SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464628 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464628 [ RunTime:0.002134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019284,213483,223464,153060,28451,564865,913984,827510,934054,512289,653502,699208,605877,137772,464536,429983,639950,116507,104208,497596,710990,241387,875428,505188,468490,832006,490750,850552,171448,181408,1014433,1030305,43502,106175,56647,441272,224435,918980,138720,587564,470296,37047,1030757,875427,864886,493377,872935,11689,234463,647548,637178,391265,509650,448306,186468,77458,492506,412313,973436,378686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]