SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542047 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542047 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637084,621384,628172,535107,291188,209073,333545,301045,200543,982298,362053,765256,11554,107696,582921,497848,234019,952012,973152,493738,298355,4009,645624,778597,34577,293059,120883,469910,204119,131061,214469,215852,482117,268893,859124,578290,794050,817435,310586,553876,61656,699059,354823,327597,592557,365654,893891,423370,451296,629438,850210,933568,124963,935486,279492,731501,919617,220673,735566,8790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]