SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537488 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537488 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289111,1009098,281873,1014153,869382,1018410,315991,172303,815759,165846,915672,1013764,1032842,614435,18915,921328,781642,691395,740194,281138,150320,990212,100030,562341,844468,193493,496290,816714,11181,769416,308208,752113,189419,1017115,465024,307198,487395,970298,829740,917950,727899,1018889,983832,445318,878246,471271,1000784,1041087,12032,496099,693392,555157,493376,718915,414348,776728,722448,244911,189654,748976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]