SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402926 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402926 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193711,329360,715290,188750,1041321,140578,796745,68489,816912,791906,458272,980430,768267,1021664,10081,851671,817712,331908,971895,763921,600692,731139,116636,34019,89555,1010432,158043,167389,710039,265167,21340,450157,881392,234642,490045,259973,150643,560432,117738,929206,861462,902270,103789,141871,714920,309574,654845,64560,514490,97732,49445,911108,274882,443480,333157,201974,801628,815965,239908,719068) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]