SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492410 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492410 [ RunTime:0.002230s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021708,283894,501854,58046,25377,344559,127372,484460,626710,77348,456366,156741,741659,988946,218879,953174,315881,1039801,783586,1045632,3305,631421,1010657,626404,332291,526582,99194,616381,538549,200107,363974,323551,161915,912716,682521,705757,274077,637280,819246,1035385,374066,917245,7418,877283,643555,929507,347352,647061,229740,366519,245262,421325,737237,294018,261853,101661,677808,253442,182381,767816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000403s ]