SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006209 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006209 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731018,617640,320888,804793,280867,669547,520608,1004836,264444,1003427,270014,881281,138504,682953,76044,994158,182508,19485,650209,570019,882910,434363,512027,802327,591578,498154,751551,697362,797425,582439,652599,42224,377874,637392,968511,363565,796101,422867,456152,567242,742199,400301,830807,21674,676382,958818,937350,909069,141771,405020,702155,308984,426634,501163,978072,720738,509017,549331,283507,536938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]