SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001442s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805221 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805221 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65922,226697,500547,440557,139846,586891,71150,331256,173719,894421,659003,842142,1017464,145818,470360,750294,766437,1026582,203013,1030962,671308,874704,452601,48223,350039,913847,242977,735508,137468,653992,557606,163152,518171,634544,609831,702094,298249,1023382,728479,81550,155318,710186,568008,672082,182985,566163,216251,569048,606293,126795,325108,57381,377586,917248,530888,529761,846277,883266,49511,589733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]