SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002281 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002281 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2637,733460,705210,305665,6960,731302,186162,415300,565772,988344,660623,308081,15154,661959,553328,992703,421182,456655,684802,279688,225214,12853,695875,756280,340993,903228,149244,93397,855834,65816,960237,819307,779047,738221,863259,998901,383433,134266,741901,371350,622587,453134,467337,489009,60699,753834,147468,905611,365483,832950,761744,89454,475161,37077,295077,311506,654130,326891,726470,739603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001214s ]