SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003950s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007423 LIMIT 1 [ RunTime:0.003494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007423 [ RunTime:0.003324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260824,39204,520805,451863,490556,438192,1017626,21805,693343,1024946,197874,810577,193306,96725,32846,493279,738658,881756,459288,393524,628392,81054,506532,893878,428999,985256,767891,38132,980171,807866,821135,381868,561388,723751,509997,1017432,418632,291922,680965,147092,858540,126887,1001698,292029,17047,459051,442358,586646,965028,619787,447013,438321,179763,877846,727524,635878,974767,529805,843332,1024323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]