SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499084 LIMIT 1 [ RunTime:0.000975s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499084 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122148,43045,512308,251470,62127,1025598,473093,299113,774165,832403,78920,273329,945063,987482,452438,215063,28141,20186,493901,903233,891963,693288,79132,216306,811858,13372,860815,230340,672696,454656,793964,201825,38383,830641,870812,707120,477797,90691,793484,489954,49098,825365,10453,511165,762162,327606,971082,872070,802619,532442,89302,155040,612376,236868,427863,776414,591572,872705,799777,609964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]