SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431978 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431978 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439088,296232,181462,694516,434092,1017589,403014,490880,331564,962584,364758,900604,699419,894396,529420,36158,34386,225264,999996,740048,594477,260152,364240,701894,59328,146243,1034444,562878,609393,376930,996079,282461,340346,713383,363248,355145,365542,417771,4822,932417,403499,710961,596456,1044808,252,196220,631595,363934,1023220,755739,73505,213497,844229,818336,791799,823895,123065,900339,275731,314647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]