SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580213 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580213 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041644,369998,618984,486146,428488,810440,499316,719866,821221,251070,355107,1040123,692520,968221,1844,567020,35103,860028,849182,751366,348406,663358,473581,17428,330844,593647,592525,84934,796841,287470,1045627,383503,661829,628590,441048,688995,374882,744649,904385,93271,354451,340536,192486,750345,414104,79027,170046,113617,172674,893826,16455,852158,835653,990676,715099,112593,588934,386179,65130,623788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]