SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357912 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357912 [ RunTime:0.002376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829547,748127,940428,762091,34669,225423,823100,301158,102802,537710,400902,291629,988150,486827,245142,213825,189525,814771,983878,369942,260490,355639,296420,945396,1013622,300909,546494,820677,1027812,236718,488064,183204,237474,935791,322227,1027058,243950,553525,97088,151154,19365,212626,744460,964621,354960,218289,52249,150946,1047587,430880,794683,249748,260398,805477,535701,443409,88427,1042545,902664,293228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]