SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021555 LIMIT 1 [ RunTime:0.000633s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021555 [ RunTime:0.003989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437976,315427,738802,903131,671108,888137,780146,215419,147491,662612,877144,885844,502202,451313,73878,169881,683732,1006276,1013851,384286,15752,254272,232879,730101,137114,943929,941993,174765,310052,35875,1005819,920468,388670,1014108,44823,59852,417814,944051,842306,605888,655846,675940,866248,1003334,550918,639737,36825,876487,931353,977409,654093,50342,313468,885305,1026655,956824,653012,961632,27838,753013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002292s ]