SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 791218 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 791218 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977108,463481,920676,896223,206717,930073,251760,926364,499782,637182,1020221,910507,128342,450947,419826,729991,443732,787084,439616,479696,636726,429151,268445,757413,687653,921,357601,732862,507909,143294,118169,12020,428483,136733,465535,856240,42843,572332,685951,103600,995351,924632,279266,282315,512767,1030881,77415,386724,521010,16725,972530,156532,36593,517800,2836,910786,387147,976845,561680,731417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 791218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 791218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]