SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691012 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691012 [ RunTime:0.003920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293136,886673,448653,264862,852568,649907,829529,718371,471298,556807,445980,433716,1009190,138386,847983,181683,379338,965192,316791,625359,276808,351584,157593,217548,337343,690934,321873,759244,524193,874181,187735,413385,6857,890670,599427,904946,761754,866455,688749,57309,881612,289639,27985,73749,176208,644656,341525,469828,144008,215419,986770,77491,521347,1005730,529069,376536,545552,122429,1035382,72822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]