SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447691 LIMIT 1 [ RunTime:0.001470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447691 [ RunTime:0.003561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214873,1043262,887371,863752,777193,699028,562364,953108,256594,288833,38683,790718,609838,241492,583312,149405,367807,1039813,741427,290909,268417,865727,290302,648437,93692,749811,694460,539498,21977,232032,215769,196599,548762,353357,377200,801410,990164,88868,874939,949700,14455,369634,540603,979991,631268,348934,1022818,445442,96761,821021,130029,557550,537493,27496,789956,318896,711673,154539,631381,797843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]