SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546752 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546752 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102967,49166,631531,763107,213369,546559,410902,945571,640674,472347,349899,414689,185971,43407,683481,256225,892015,878609,24698,406972,118854,1001659,902048,956958,322529,173316,905021,42084,900091,219547,307044,509080,945292,451404,190831,13475,960247,808404,380380,762520,256005,8545,436550,832942,370999,166762,752261,843366,1034038,909207,187104,135367,580636,478651,635597,408956,240708,933030,704522,707873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]