SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045872 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045872 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484872,662171,86448,419040,904736,123339,165308,1008331,560477,819744,598756,798215,700878,180016,669519,155068,997765,862958,584410,1003322,258538,1026668,603555,990483,736643,912678,513235,637463,211357,176503,560750,589231,939976,261603,730482,371043,1027754,248578,848271,870688,383210,104709,141649,176665,267939,935401,303783,271300,811013,109427,352365,545098,462143,159557,908189,630902,96980,893645,694970,388407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]