SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4218 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4218 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773790,1046829,625527,421101,114839,105076,1038301,1034876,917338,1023917,944629,875983,662470,554677,98419,175430,87470,916798,1018714,339055,708360,173991,267011,638131,378374,116023,436649,213452,28827,595289,243684,706017,189787,648636,428910,298406,897633,152681,522199,1044085,323197,899763,911497,509694,78586,528481,1022091,651495,85827,510412,408784,102624,1045072,705178,194963,136554,298847,453177,803869,184024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]