SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511450 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511450 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704750,13817,389722,446797,457992,1001210,873826,722572,985669,142547,603475,65021,432440,83879,537663,269853,135347,894262,423856,308447,949789,769821,394489,855492,716532,239577,308214,557680,642847,528516,784840,399176,915581,67477,375872,26923,293730,672035,135483,705486,516036,46656,286888,129785,896632,256026,318214,399643,9491,687919,330245,127261,239101,966561,976892,848151,108220,360987,428324,47186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]