SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437223 LIMIT 1 [ RunTime:0.001540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437223 [ RunTime:0.001623s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558092,424821,274499,129871,703117,457338,1006300,672523,578297,251022,615208,356428,823457,991602,687050,323269,1004412,34058,947355,561343,845774,322365,791025,137873,920222,802683,998459,13551,538756,615558,282249,671340,100398,816096,690326,465678,833203,889113,748188,117008,623705,737190,882334,809325,771447,664129,405690,173473,408195,325867,213426,892306,137924,635898,291273,595639,27900,69752,779356,17289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003286s ]