SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028085 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028085 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031324,217296,335315,638420,800300,509788,136668,1023556,42919,192495,357884,729279,333491,347639,85920,3983,106689,946694,999873,251780,431426,741713,864468,555928,410928,784321,140281,137013,241139,665164,300052,968,189123,493763,25866,579834,393122,288426,97841,550465,433350,681067,37808,355812,1040588,401509,304432,660917,659717,228161,255612,789513,183136,907882,987204,87693,501727,327982,751771,728011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]