SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414204 LIMIT 1 [ RunTime:0.000796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414204 [ RunTime:0.004633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (225418,79805,483479,139187,245886,432288,616746,548414,575621,337084,552562,705510,631440,88183,741437,97816,918445,213396,471002,601539,347914,845574,224248,525805,241012,306174,40919,34958,259022,637820,414566,577071,405819,548049,186697,208619,938769,476524,301374,875886,956007,127233,235954,398407,143830,382772,719871,716549,543230,907098,203204,822507,566932,992366,995961,410138,278186,175431,276688,371134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414204 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414204 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000989s ]