SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004062 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004062 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301378,85127,1038338,115476,264132,283264,523802,975678,634039,668565,820687,984053,294243,1009069,1023202,551939,408893,326457,883447,1033047,537561,704846,1036087,374078,551932,167942,489551,769035,439095,667195,816754,831231,206366,814130,158229,710724,1032831,906140,849870,429473,1024338,401698,376076,481626,562531,276171,310300,904724,385870,361880,405402,218528,142877,670359,28103,555589,1014619,739253,738481,901880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]