SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419960 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419960 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358139,729951,231246,651474,146203,340343,602427,688808,427795,487634,29617,442523,97350,798457,1000756,422062,1012714,283431,486373,711329,1033077,332894,798854,269588,764128,626276,767589,599983,899636,637015,505635,921856,219642,57077,468017,927083,530684,158452,647696,821491,796961,53517,676589,676440,324500,509212,379750,796391,508763,733946,718311,446424,566069,790782,573523,1027490,644536,1032924,129019,547239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]