SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426419 LIMIT 1 [ RunTime:0.000980s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426419 [ RunTime:0.004845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334168,736738,198934,298829,539736,695243,1020926,388004,241110,552153,278359,684610,943155,918710,186414,513681,764149,751542,835916,22114,657657,513273,581075,748880,894332,196438,213502,513537,350846,741125,264804,31041,725648,361203,658840,601544,954873,184013,767465,263354,744515,482666,363279,829687,887912,9022,855414,720310,477884,455156,487924,922474,699931,707011,947538,411146,704,463535,342340,95424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]