SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820101 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820101 [ RunTime:0.002380s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011729,880060,49837,662034,473647,1033558,455952,701224,794677,161888,878804,808386,705539,929977,390422,701719,930785,837236,456161,248620,338146,1020015,925199,267775,576326,459944,618802,706048,298520,13627,411353,925444,903340,390768,479374,1047580,1002581,43292,748111,139056,978717,333701,210994,90079,798977,385933,118958,332083,937575,172664,726169,1012536,20005,987337,243636,970342,32343,739960,932648,420188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]