SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422835 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422835 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295095,976779,993296,836370,212252,428933,831735,1031414,654586,361575,806849,430726,796395,725986,145002,251573,268527,252303,110328,508108,134578,779168,677938,839340,978127,390222,21399,492215,148081,175244,380799,389804,31173,567579,213339,771848,973024,694542,526562,843613,292916,374390,666138,323022,132460,321968,687969,556339,156048,910050,904333,1029054,354994,431237,934894,143268,339830,800105,514232,643805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]