SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494583 LIMIT 1 [ RunTime:0.001819s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494583 [ RunTime:0.004888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394651,68511,496934,1032378,871022,513035,296105,460258,601006,624751,371800,787070,985475,292621,626405,501346,223235,60060,1045687,455081,406291,965708,577670,503924,648237,766881,338621,703239,360617,971547,424219,644053,291150,648938,989848,436681,603092,629519,45115,655413,887483,915216,738184,22308,125697,148793,254429,274908,841431,152766,260654,282557,904161,381697,773949,228016,57641,58623,329929,387458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000994s ]