SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439872 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439872 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193490,202783,1010482,756194,20383,79132,423131,986881,857244,109285,906596,88328,121586,41559,58944,495848,29843,624949,431186,614866,664588,188713,669920,390059,485508,526534,396695,598801,179026,377629,725291,477082,841977,970131,684050,836435,139380,408927,923110,713080,848548,145574,380885,515368,347130,695329,376327,37587,45580,858640,729858,948573,763497,540503,253697,400340,470251,583817,796359,796898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]