SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502693 LIMIT 1 [ RunTime:0.000538s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502693 [ RunTime:0.001929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (940158,95674,915520,513300,748774,1045167,935789,736983,271319,982138,912513,415764,691203,986295,87413,83846,144244,490283,950127,890505,494437,617740,701711,740548,163625,263362,902226,646986,224869,304448,108813,827091,520106,376358,392991,298568,363375,488099,134881,762818,641599,706713,1029005,992846,777944,850476,713916,647859,625728,215227,84256,656551,443105,18305,667397,812899,564360,995652,79023,37853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]