SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519533 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519533 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417339,283088,812375,93996,453700,908981,578360,225343,834343,722194,585008,1028064,38757,128834,420371,617558,960934,636468,196577,971654,128024,1665,1029617,82453,84809,401202,537443,747987,95913,789810,795588,294086,688802,346647,520371,809319,616298,393425,101935,529853,690055,290799,104684,121135,457672,916002,58957,535938,249710,400618,455423,70033,945196,344254,658048,668433,975479,359263,139817,688349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001576s ]