SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038381 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038381 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (277332,69750,673065,521158,429390,872197,464714,205847,762029,796680,198824,849709,274590,809446,217406,250240,866398,607172,359482,594590,855978,1021439,284074,992685,50234,273565,151250,641060,157177,945982,706830,977218,903759,779403,413691,162446,722872,306259,672808,419409,176650,278887,76451,619356,850544,236777,348341,793527,464268,34514,569753,764009,516673,795783,759179,49764,151883,628994,921491,88983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]