SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20404 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20404 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492858,622694,28015,488139,408491,636955,469179,952784,426014,183201,1032734,38226,148237,602542,735385,788636,617820,8683,1040687,604134,694318,756613,482939,795291,478915,695438,151605,969669,637501,413145,155499,888312,1027819,380228,69830,455598,822500,449804,38010,2502,281439,355125,910640,571001,677528,137080,692408,1033356,647302,674821,607774,424329,392576,314294,610668,755706,575872,55944,639906,516592) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002934s ]