SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345842 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345842 [ RunTime:0.003494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642244,541527,529668,838583,541642,789486,1001448,1009214,1011425,247688,191398,598389,1033791,637844,318386,1030692,661521,962940,377675,1012444,1029554,825095,204328,229839,227247,680912,845416,971337,482382,645259,1034721,165549,25172,22068,303082,669144,360089,561840,330059,793612,259240,550620,829385,481029,869443,496841,803533,855544,867097,706942,407010,62018,546091,83450,759544,725901,105083,586286,982745,421783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]