SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310602 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310602 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693520,627805,962880,1035489,452592,910882,638968,566987,49776,837086,325885,502822,336054,397812,399612,296670,39460,588357,892486,393354,775448,484934,304150,190359,882111,399705,586067,990971,387156,423832,48655,141458,18044,881661,485336,967027,477695,701854,805353,245972,408548,118351,129247,613704,789989,688966,703925,582719,694386,291975,592527,217364,202241,147211,819811,675104,556361,1026719,44421,425087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003553s ]