SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004064s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400700 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400700 [ RunTime:0.005321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130317,930117,438783,352286,742005,237587,656471,248703,497828,765807,1048507,732310,507931,473011,881575,445988,53104,723496,958626,346923,840017,935580,568885,1044854,814838,621599,22424,253544,873508,646925,221726,410023,589558,640534,221090,433532,507751,640690,524122,873598,667248,46336,311449,300880,127534,657972,536048,371810,929026,549829,811685,485061,868480,193755,33184,298512,828828,425129,602326,413840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]