SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020770 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020770 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976016,427744,43148,1001957,296263,189039,346755,413426,79237,695404,982049,153453,728054,343910,509762,772992,860099,915866,679220,503300,788313,512739,875527,1042674,945866,431118,998969,141165,69047,644284,910237,612873,474392,277629,1006310,863132,767471,395704,1036302,432689,451375,218288,672998,898510,953163,778518,620840,306770,220407,636424,159477,664869,414343,306613,218588,482403,257265,255312,751668,893967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]