SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004454 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004454 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989890,1009419,57958,256748,371508,129283,601400,481362,197328,105288,338185,692237,341856,1027531,968979,870972,258435,51154,237170,47015,870185,893417,761705,380175,77741,1030387,193906,857199,523756,137249,119639,553326,265284,405025,62508,1016392,858217,835337,607542,550837,849543,781315,81079,47072,660054,755140,910351,1026790,544676,424340,1017786,1043458,919103,1040137,1025201,271462,722131,605198,7490,905667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004825s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]