SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412033 LIMIT 1 [ RunTime:0.000694s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412033 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149629,63747,147912,116140,771904,766446,141163,183189,751965,587171,629198,553739,834094,89127,703250,976858,74206,901570,435189,964042,716139,352471,201586,196287,386374,308132,833635,1031781,409763,875307,102371,222349,613091,96931,367223,230185,719845,665841,419326,133841,1047646,664301,737519,691923,878620,722647,35506,675626,901171,323359,116946,534535,178945,656648,1009163,415768,428376,452690,985363,745164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]