SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 922913 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 922913 [ RunTime:0.001399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022314,178281,331975,607327,112272,45533,408464,623595,673745,348554,279912,418483,396119,1027455,300969,697198,873541,304058,349361,1030984,527530,296429,322560,687308,1017251,459094,585157,468680,86523,225153,452899,79299,268423,620557,643920,302841,667111,773855,444363,529556,313959,353490,917911,947306,457421,722189,322763,871405,593481,363282,204022,124240,362411,192271,497125,947126,769734,67420,385041,214039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 922913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 922913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001442s ]