SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 657303 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 657303 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570586,2334,859029,102664,37137,723542,599263,813754,939048,1013241,654687,642128,605562,707491,956791,570942,181956,182471,17937,1018854,900263,1048337,362305,946303,690058,130574,579506,557763,56331,1004953,538292,539850,780148,744927,474390,926520,866617,90941,853070,211937,799104,688585,302794,40720,887771,897972,878257,648990,479603,447585,334664,636933,957102,114538,811386,467035,70244,999004,612911,914022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 657303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 657303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001241s ]