SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54371 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54371 [ RunTime:0.010816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120298,621601,198831,516832,618988,872698,331709,261875,763914,854120,774981,326921,777932,752464,164015,68289,375571,97046,466559,778706,936960,337228,150285,266690,870448,315771,6461,1008942,661834,16153,226570,956617,705430,740833,554975,822188,262376,662715,653364,367853,782737,826061,277625,99294,581780,477497,868804,560908,1018003,967628,119192,365320,266799,520034,572656,937857,419721,178744,854840,78335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001306s ]