SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149711 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149711 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040291,706104,1016492,996955,647885,766869,1032167,815296,354869,714080,523315,591725,461387,1012055,999313,691454,353523,893672,668928,974448,406506,403229,460303,902418,363375,438185,987531,4129,369312,495265,897551,1017740,234920,791032,697889,508352,989368,246432,841459,910330,465261,865376,538425,826787,675668,886237,916334,936187,395817,644628,192915,271508,296387,1023375,454498,793657,358096,927958,531119,706978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]