SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683098 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683098 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330042,265324,537858,376284,914703,587208,35458,243754,755209,810172,395072,322481,126171,408695,523635,111778,879222,875655,811350,526270,128218,542433,55228,105928,136143,139070,489670,681669,1025446,235093,903122,916528,749890,1027355,75763,438104,493782,245945,701507,368565,125400,805209,163183,7974,387384,989240,155919,112275,492136,853020,749145,361689,810669,26846,894810,264966,301023,887809,515261,120491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]