SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002516s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204208 LIMIT 1 [ RunTime:0.000495s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204208 [ RunTime:0.003199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972569,323246,230918,16026,630418,586297,382904,850055,780001,505168,23012,496207,519431,1007682,361691,23985,1012127,930049,890649,967811,402533,97926,1014855,635167,18233,669299,713382,875120,411604,1013952,368749,975643,878851,559822,567678,695517,300939,602144,26253,59362,393536,968545,585648,835618,790151,872941,701555,288365,801334,638380,912548,213311,848004,203860,673979,434736,12329,250940,511025,695543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002443s ]