SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538038 LIMIT 1 [ RunTime:0.001926s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538038 [ RunTime:0.002082s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632065,659545,956576,359376,1008996,580168,120911,351367,155779,273854,570084,863698,221623,939343,72703,267005,593792,637864,191507,394402,554565,552729,732874,331328,994317,609951,77499,787536,43276,651886,23459,43273,489832,735639,871083,547831,1042494,808355,659885,537830,761037,981913,108614,775568,522208,731129,744580,917438,174503,889462,856578,403498,928699,285797,401027,497475,570924,279642,505249,9909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002756s ]