SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038538 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038538 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278013,445397,290561,717648,322228,323023,1034849,271241,893013,1024178,6675,346745,890099,76802,686291,209142,903293,523249,346137,281848,466227,11661,325750,462252,215254,590122,54681,668939,705115,991623,932132,563725,860204,1006487,981389,98672,292511,738094,1021779,116132,990170,360546,357442,253304,241593,969568,125379,210560,905731,5015,280314,485840,14379,1019765,836756,185443,178995,116720,144621,658055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002931s ]