SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048609 LIMIT 1 [ RunTime:0.001217s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048609 [ RunTime:0.003209s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117812,209450,281332,611330,776745,666362,456153,516195,235879,752781,79559,822366,924089,280567,302954,73471,739635,233351,720835,118906,324848,801083,846562,423351,567340,877218,1028958,1040834,821641,459376,295417,1026469,1031768,1042898,285346,973815,476039,978677,400645,50034,704336,595468,435675,949198,494986,338621,900105,1035919,390381,47335,554897,870648,119391,861680,198511,283186,540107,51208,37986,719139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]