SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193423 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193423 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186825,403525,326830,291618,252702,931275,787042,583680,949031,52237,698797,496751,44176,710684,706360,943172,131139,998405,972335,389495,411731,314146,477523,392743,462795,1027838,634583,912654,748966,859890,782210,24729,605496,21968,323673,162631,855628,125755,43399,623918,1045839,649079,132083,253649,815577,1024063,654965,530149,979954,58675,682202,211639,1029811,406270,370028,887161,6848,315712,229193,531977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]