SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004820 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004820 [ RunTime:0.002053s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047237,830020,534519,275177,710467,76106,414351,461473,4046,269746,590198,65089,684284,332728,654744,559280,147485,271512,1044991,558365,587183,914265,922323,1007001,297893,130640,71956,796676,870280,405000,437858,791815,1036118,983804,196294,842530,308888,995738,231472,380152,240059,112365,363389,289039,295411,456245,1036975,688306,281587,654317,550259,269915,342381,92275,183870,405343,720928,817481,662643,875046) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]