SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685362 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685362 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938891,682560,436440,1027990,118642,808102,80538,109037,84772,356607,189850,874636,852526,451972,494116,190569,479475,21471,784368,672536,145372,401236,274049,1019856,438139,56387,819336,636433,423392,803459,395689,10395,48342,696102,280327,593168,78101,547737,242286,844127,531460,713840,621438,975339,909738,389298,1044119,418698,72940,525152,893393,562280,690151,356767,528284,162698,780405,182780,334066,496294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685362 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685362 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]