SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467258 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467258 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482812,671883,493826,101864,588191,5257,851976,249780,175203,433138,314209,781792,909633,74252,548404,817940,383060,82157,269630,537190,258182,543612,378669,639174,754828,923823,950035,743633,610056,810403,452796,442796,216963,1038858,418889,351838,246413,296543,456506,336039,205578,1039760,747375,414592,32891,344926,117845,1017523,338082,200964,719798,482144,542730,386458,268743,196939,903519,868267,902099,306602) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]