SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41990 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41990 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707325,722933,504058,890830,245482,510974,818529,245138,773727,286060,840911,87206,757212,439325,388803,966006,160344,233321,996984,424667,524892,556943,378648,185666,552233,466232,779035,1012889,442075,829432,800798,1020477,119320,765938,181246,289121,372895,778276,834295,394114,880767,577084,1028252,89729,423009,4451,322894,142048,575396,71635,81517,71148,679686,905362,998997,1033449,985690,683078,645732,554038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001822s ]