SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020121 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020121 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481523,296624,832763,406018,179496,526667,310305,104217,198056,518229,748161,500526,799939,693780,856058,623850,91575,858255,283848,791329,629890,967445,369879,913593,82914,246886,966980,142040,229813,625086,942301,909023,706790,969717,508360,1047440,100330,751925,753218,834235,47549,152478,795246,468496,281020,811645,1034824,354285,756200,582770,401749,831237,676613,25130,40996,57354,907014,807283,724640,283274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]